TrimRight (str)

TrimRight and RTrim (str) are equivalent functions. However, TrimRight is preferred in Crystal syntax, whereas RTrim is preferred in Basic syntax.

Arguments

TrimRight(str)

Where str is a text string.

Returns

Text String

Action

TrimRight removes all spaces to the right of a string or data field which is stored left-justified in a database.

Typical uses

• Use this function any time there are trailing blanks in a text object that may interfere with an alignment of text strings, a character count, or with a calculation (if the string is eventually converted to a Number).
• Use whenever you combine (concatenate) justified text strings and want to have the proper spacing between strings.

Examples

The following examples are applicable to both Basic and Crystal syntax, although RTrim is preferred in the latter:

TrimRight("Al/4520/B12    ")

Returns "A1/4520/B12".

TrimRight({file.REFERENCE})

Returns "Bal Fwd." where the text string "Bal Fwd.    " is left-justified in the field.

Related topics

Trim (str)

TrimLeft (str)